<?php 
/*
 * This file is part of Big Picture Gallery (BPG).
 *
 * Big Picture Gallery (BPG) is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Big Picture Gallery (BPG) is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Big Picture Gallery (BPG).  If not, see <http://www.gnu.org/licenses/>.
 */

class Album {
  
  public function fetchAlbums() {
    
    $dbh = Db::getInstance();
    
    $rows = $dbh->query("
    	SELECT id, titre, description, illustration, dossier 
    	FROM gallery
    ")->fetchAll(PDO::FETCH_ASSOC);
    
    foreach($rows as $row) {
      if($row['illustration'] == 0) {
        $photo = $dbh->query("	
        	SELECT titre AS imageTitle, 
						description AS imageDescription, 
						chemin AS imagePath 
					FROM photo 
					WHERE id_gallery = " . $row['id'] . "
					ORDER BY RAND( )
					LIMIT 1
        ")->fetch(PDO::FETCH_ASSOC);
       
      } else {
        $photo = $dbh->query("	
        	SELECT titre AS imageTitle,
						description AS imageDescription, 
						chemin AS imagePath 
					FROM photo 
					WHERE id = " . $row['illustration']
        )->fetch(PDO::FETCH_ASSOC);
      }
      
      $photo['imagePath'] = "album/" . $row['dossier'] . "/" . $photo['imagePath'];
      $result[] = array_merge($row, $photo);
    }
    return $result;
  }
}

?>